<!DOCTYPE html>
<html lang="zh-CN" xmlns:th="http://www.thymeleaf.org">
  <head>
    <meta charset="UTF-8">
    <title>欢迎页面-X-admin2.0</title>
    <meta name="renderer" content="webkit">
    <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
    <meta name="viewport" content="width=device-width,user-scalable=yes, minimum-scale=0.4, initial-scale=0.8,target-densitydpi=low-dpi" />
    <link rel="shortcut icon" href="/favicon.ico" type="image/x-icon" />
    <link rel="stylesheet" href="/css/font.css">
    <link rel="stylesheet" href="/css/xadmin.css">
    <script type="text/javascript" src="https://cdn.bootcss.com/jquery/3.2.1/jquery.min.js"></script>
    <script type="text/javascript" src="/lib/layui/layui.js" charset="utf-8"></script>
    <script type="text/javascript" src="/js/xadmin.js"></script>
    <!-- 让IE8/9支持媒体查询，从而兼容栅格 -->
    <!--[if lt IE 9]>
      <script src="https://cdn.staticfile.org/html5shiv/r29/html5.min.js"></script>
      <script src="https://cdn.staticfile.org/respond.js/1.4.2/respond.min.js"></script>
    <![endif]-->
  </head>
  
  <body>
    <div class="x-nav">
      <span class="layui-breadcrumb">
        <a href="">首页</a>
        <a href="" id="db_source" th:attr="val=${db_source}" th:text="${db_source}"></a>
        <a>
          <cite id="db_name" th:text="${db_name}"></cite></a>
      </span>
      <a class="layui-btn layui-btn-sm" style="line-height:1.6em;margin-top:3px;float:right" href="javascript:location.replace(location.href);" title="刷新">
        <i class="layui-icon" style="line-height:30px">ဂ</i></a>
    </div>
    <div class="x-body">
      <!--<div class="layui-row">-->
        <!--<form class="layui-form layui-col-md12 x-so">-->
          <!--<input class="layui-input" placeholder="开始日" name="start" id="start">-->
          <!--<input class="layui-input" placeholder="截止日" name="end" id="end">-->
          <!--<div class="layui-input-inline">-->
            <!--<select name="contrller">-->
              <!--<option>支付状态</option>-->
              <!--<option>已支付</option>-->
              <!--<option>未支付</option>-->
            <!--</select>-->
          <!--</div>-->
          <!--<div class="layui-input-inline">-->
            <!--<select name="contrller">-->
              <!--<option>支付方式</option>-->
              <!--<option>支付宝</option>-->
              <!--<option>微信</option>-->
              <!--<option>货到付款</option>-->
            <!--</select>-->
          <!--</div>-->
          <!--<div class="layui-input-inline">-->
            <!--<select name="contrller">-->
              <!--<option value="">订单状态</option>-->
              <!--<option value="0">待确认</option>-->
              <!--<option value="1">已确认</option>-->
              <!--<option value="2">已收货</option>-->
              <!--<option value="3">已取消</option>-->
              <!--<option value="4">已完成</option>-->
              <!--<option value="5">已作废</option>-->
            <!--</select>-->
          <!--</div>-->
          <!--<input type="text" name="username"  placeholder="请输入订单号" autocomplete="off" class="layui-input">-->
          <!--<button class="layui-btn"  lay-submit="" lay-filter="sreach"><i class="layui-icon">&#xe615;</i></button>-->
        <!--</form>-->
      <!--</div>-->
      <!--<xblock>-->
        <!--<button class="layui-btn layui-btn-danger" onclick="delAll()"><i class="layui-icon"></i>批量删除</button>-->
        <!--<button class="layui-btn" onclick="x_admin_show('添加用户','./order-add.html')"><i class="layui-icon"></i>添加</button>-->
        <!--<span class="x-right" style="line-height:40px">共有数据：88 条</span>-->
      <!--</xblock>-->
      <table class="layui-table" lay-size="sm">
        <thead>
          <tr>
            <th>#</th>
              <th>数据库ID</th>
            <th>表ID</th>
              <th>表名称</th>
              <th>表类型</th>
            <th>创建时间</th>
            <th>最后访问时间</th>
            <th>拥有者</th>
            <th>保留字段</th>
            <th>序列化配置信息</th>
            <th>视图的详细HQL语句</th>
            <th>视图的原始HQL语句</th>
          </tr>
        </thead>
        <tbody>
          <tr th:each="table : ${tables}">
            <td th:text="${tableStat.count}"></td>
              <td th:text="${table.DB_ID}"></td>
            <td th:text="${table.TBL_ID}"></td>
            <td>
              <a title="查看" href="javascript:;" class="x-a view_table"
                 th:text="${table.TBL_NAME}"
                 th:attr="dbname=${db_name}"
                 style="font-size: 14px;">
              </a>
            </td>
              <td th:text="${table.TBL_TYPE}"></td>
            <td th:text="${table.CREATE_TIME}"></td>
            <td th:text="${table.LAST_ACCESS_TIME}"></td>
            <td th:text="${table.OWNER}"></td>
            <td th:text="${table.RETENTION}"></td>
            <td th:text="${table.SD_ID}"></td>
            <td th:text="${table.VIEW_EXPANDED_TEXT}"></td>
            <td th:text="${table.VIEW_ORIGINAL_TEXT}"></td>
          </tr>
        </tbody>
      </table>
      <div class="page">
        <div>
          <a class="prev" href="">&lt;&lt;</a>
          <a class="num" href="">1</a>
          <span class="current">2</span>
          <a class="num" href="">3</a>
          <a class="num" href="">489</a>
          <a class="next" href="">&gt;&gt;</a>
        </div>
      </div>

    </div>
    <script>
      layui.use('laydate', function(){
        var laydate = layui.laydate;
        
        //执行一个laydate实例
        laydate.render({
          elem: '#start' //指定元素
        });

        //执行一个laydate实例
        laydate.render({
          elem: '#end' //指定元素
        });
      });

      function getSourceAndDBname() {
          var db_source = $("#db_source").attr("val");
          var db_name = $("#db_name").text();
          return "&db_source="+db_source+"&db_name="+db_name;
      }

      $(".view_table").click(function () {
          var db_source = getSourceAndDBname();
//          var db_name = $("#db_name").val();
          console.info(db_source)
//          console.info(db_name)

          var $this = $(this);
          var tname=$this.text();
          var jsobj = $this[0];//将jquery对象转为dom对象
          var dbname=jsobj.getAttribute("dbname");
          x_admin_show("查看["+tname+"]表信息",'/meta/viewTable?table_name='+tname+'&db_name='+dbname+getSourceAndDBname())

      });


      /*用户-停用*/
      function member_stop(obj,id){
          layer.confirm('确认要停用吗？',function(index){

              if($(obj).attr('title')=='启用'){

                //发异步把用户状态进行更改
                $(obj).attr('title','停用')
                $(obj).find('i').html('&#xe62f;');

                $(obj).parents("tr").find(".td-status").find('span').addClass('layui-btn-disabled').html('已停用');
                layer.msg('已停用!',{icon: 5,time:1000});

              }else{
                $(obj).attr('title','启用')
                $(obj).find('i').html('&#xe601;');

                $(obj).parents("tr").find(".td-status").find('span').removeClass('layui-btn-disabled').html('已启用');
                layer.msg('已启用!',{icon: 5,time:1000});
              }
              
          });
      }

      /*用户-删除*/
      function member_del(obj,id){
          layer.confirm('确认要删除吗？',function(index){
              //发异步删除数据
              $(obj).parents("tr").remove();
              layer.msg('已删除!',{icon:1,time:1000});
          });
      }



      function delAll (argument) {

        var data = tableCheck.getData();
  
        layer.confirm('确认要删除吗？'+data,function(index){
            //捉到所有被选中的，发异步进行删除
            layer.msg('删除成功', {icon: 1});
            $(".layui-form-checked").not('.header').parents('tr').remove();
        });
      }
    </script>
    <script>var _hmt = _hmt || []; (function() {
        var hm = document.createElement("script");
        hm.src = "https://hm.baidu.com/hm.js?b393d153aeb26b46e9431fabaf0f6190";
        var s = document.getElementsByTagName("script")[0];
        s.parentNode.insertBefore(hm, s);
      })();</script>
  </body>

</html>